﻿-- =============================================
-- Author:		gsj
-- Create date: <Create Date,,>
-- Description:	<Description,,>
-- =============================================
CREATE PROCEDURE [dbo].[proc_Receipt_GetItem]
	(	
	@Id int
	)
AS
BEGIN

	select [id]
      ,[CompanyId]
      ,[CompanyName]
      ,[CusName]
      ,[OrderId]
      ,[NOE_Flag]
      ,[Je]
      ,[RDate]
      ,[Memo]
      ,[LDate]
      ,[LUserName]
      ,[LEName]
      ,[Flag]
      ,isnull([CancelDate],'1900-1-1') as [CancelDate]
      ,[CancelUserName]
      ,[CancelEName]
      ,[CancelMemo]
      ,RItem ,
			RID ,
			SEName ,
			SUserName ,
			PaymentTypeId,
			PaymentTypeName,
			BankId ,
			BankName 
      from Receipt where id=@Id 
	
END
